package com.bgs.travelapp.user.mapper;

import com.bgs.travelapp.user.entity.UserEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.BaseMapper;

@Mapper
public interface UserMapper extends BaseMapper<UserEntity> {

    @Select("select count(0) from user where mail = #{mail} and id != #{id}")
    Integer checkMailEdit(@Param("mail") String mail,@Param("id") Integer id);
}
